<?
	include('chksession.php');
	include('conn.php');
	session_start();
   
	
	   $msg='';
        $Can_Date= $_REQUEST['Can_Date'];
       $Pax_Name= $_REQUEST['Pax_Name'];
	   $No_of_Pax= $_REQUEST['No_of_Pax'];
	   $Airline= $_REQUEST['Airline'];
	   $Sector= $_REQUEST['Sector'];
	   $Net_Rate= $_REQUEST['Net_Rate'];
	   $Refund_Amt= $_REQUEST['Refund_Amt'];
	   $Refund_Date= $_REQUEST['Refund_Date'];
	   $Agent_Rate= $_REQUEST['Agent_Rate'];
	   $Agent_Ref_Amt = $_REQUEST['Agent_Ref_Amt'];
	   $Reference_Date = $_REQUEST['Reference_Date'];
	   $Comment = $_REQUEST['Comment'];
	   $enteredby = $_SESSION['username'];
	    $agentid = $_REQUEST['agentid'];
	   //$enteredby = $_REQUEST['enteredby'];
	   //$entrydt = $_REQUEST['entrydt'];
	      
	  // echo $Can_Date.",".$Pax_Name.",".$No_of_Pax.",".$Airline.",".$Sector.",".$Net_Rate.",".$Refund_Date.",".$Agent_Rate.",".$Agent_Ref_Amt.",".$Reference_Date.",".$Comment.",".$enteredby.",".$entrydt;
	   
	   
		
		$sql="insert into canceltrandetails(Can_Date,Pax_Name,No_of_Pax,Airline,Sector,Net_Rate,Refund_Amt,Refund_Date,Agent_Rate,Agent_Ref_Amt,Reference_Date, Comment,enteredby,entrydt,agentid)
		values('".$Can_Date."','".$Pax_Name."',".$No_of_Pax.",'".$Airline."','".$Sector."',".$Net_Rate.",".$Refund_Amt.",'".$Refund_Date."',".$Agent_Rate.",".$Agent_Ref_Amt.",'".$Reference_Date."','".$Comment."','".$enteredby."',sysdate(),".$agentid.")";
		
		echo $sql;
		$res=mysql_query($sql);
		if($res)
		$msg='Record saved successfully';			
		echo $msg;
?>